SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Escape to your own slice of paradise with this stunning 3-bedroom, 2.5-bath home offering breathtaking, expansive views! Nestled on 21 acres of picturesque land, this property is perfect for nature lovers, hobby farmers, or anyone seeking tranquility while still being close to Dartmouth, schools, shopping, restaurants. Enjoy the perfect blend of modern comfort and outdoor living with an attached garage, a spacious barn, and miles of trails right outside your door.The master suite is a spacious retreat with a private bath and walk in closet while the two additional bedrooms offer ample space for family, guests, or a home office with hi speed internet. The open living and dining areas feature large windows that bring the scenic surroundings indoors, creating a bright and welcoming atmosphere.Enjoy the fireplace warmth as you watch the wildlife through the many windows.Additional features include an attached 2-car garage for secure parking and storage, as well as a barn that's perfect for animals, equipment, or hobbies. The expansive 21 acres includes fields and trails, providing endless opportunities for outdoor recreation, whether it’s hiking, horseback riding, cross country skiing, snowmobiling,or just enjoying the peaceful surroundings.**The 126 acre abutting lot is also available for sale. See MLS#5027346. Some photos are virtually staged.
Description:Bring you chickens, your green thumb and your swim suit and enjoy everything this 3.2+/- acre property has to offer approx. 15 minutes from Dartmouth College and Dartmouth Health! This 3-4 bedroom, 2.5 bedroom home features charming exposed beams, open eat-in kitchen/dining room with a wood fireplace, cozy living room with reading nook and a wood stove for those chilly winter nights, a patio leading to a screened porch, garden space, multiple outbuildings and a swimming and skating pond! This home has something for everyone including a trail network within walking distance and Trescott trail access off of Dogford Rd. for mountain biking about 3 miles away. Do you love to ski? The Dartmouth Skiway is approx. 15 minutes as well! What a spot! Delayed showings start at the Open House on Saturday, Feb 15 from 11:00-1:00. Note - Town has it listed as a 3 bedroom so we assume it's a 3 bedroom septic.
Description:This stunning residence perfectly blends sophistication and convenience, located just moments from Eastmans South Cove Activity Center. The residence combines comfort and style to create the ultimate retreat situated on over 2 private acres. The spacious living area features hardwood floors, cozy fireplace, soaring ceiling and large windows that flood the space with natural light. Enjoy a book or your morning coffee in the three season porch area offering views of the backyard oasis. The main level also features a beautiful chef's kitchen with custom cabinetry that flows to the dining area with another fireplace. Highlights of this home also boasts a library, den, morning bar area, large laundry room and first floor primary bedroom with a spacious bathroom. The upper level features another primary bedroom with a generous bathroom, guest bedroom en suite and a crafts room. Outside you will find above the two car detached garage a in-law suite or additional guest space with a bedroom, kitchen and a living area. Another two car garage area also has a beautiful spacious office or recreation area. This exceptional property is not to be missed.
Description:This light-filled, contemporary home with 3 bedrooms and 2.5 baths is situated in a highly desirable cul-de-sac located mere minutes from downtown Hanover and Dartmouth College. The kitchen opens into a bright dining area with cathedral ceiling. A sunbathed living room with fireplace, a cozy family room and a home office complete the first floor. The primary bedroom with ensuite bathroom, as well as two nicely sized bedrooms and a full bath comprise the second floor. Enjoy the options of a finished basement with natural light. The outdoor space is highlighted by a great back deck overlooking a cleared backyard. Further outdoor enjoyment awaits at Storrs Pond Recreation Area and trail network- just a mile away. A terrific home in premier neighborhood and location! The office photo is virtually staged. SHOWINGS BEGIN FRIDAY, 3/28/25.